
if exists(select name from sysobjects where name = 'sp_KhoaNichGetByMaSinhVienAndTrangThai')
	drop proc sp_KhoaNichGetByMaSinhVienAndTrangThai
go
/*
	Created by: Phuoc NH
	Created on: 5/12/2013 (dd/mm/yyyy)
	Description: 
	--

	File:$sql-scripts/Proc.sp_KhoaNichGetByMaSinhVienAndTrangThai.sql
*/

create proc sp_KhoaNichGetByMaSinhVienAndTrangThai
@masinhvien varchar(50),
@trangthai tinyint
as
begin
	select * from khoanick where masinhvien=@masinhvien and trangthai=@trangthai
end

